package de.bahn.dbs.diva.db;

import android.net.Uri;
import android.provider.BaseColumns;

public interface VorgangsMitarbeiter extends BaseColumns {

	String MIME_TYPE_DIR = Vorgang.MIME_TYPE_DIR + ".mitarbeiter";

	String MIME_TYPE_ITEM = Vorgang.MIME_TYPE_ITEM + ".mitarbeiter";

	String SIGNATUR = "signatur";

	String LABLE = "lable";

	String VORGANGS_ID = "vorgangs_id";

	String DEFAULT_SORT_ORDER = VORGANGS_ID + " ASC";

	String[] PROJECTION = { _ID, LABLE, SIGNATUR, VORGANGS_ID };

	interface CONTENT_URIS {
		Uri BASE = Uri.withAppendedPath(Vorgang.CONTENT_URIS.BASE,
				"mitarbeiter");

		Uri NACH_VORGANG = Uri.withAppendedPath(Vorgang.CONTENT_URIS.BASE,
				"mitarbeiter/aid");
	}

	interface SQL {
		String TABLE = "mitarbeiter";

		String CREATE_CODE = "CREATE TABLE " + TABLE + " (" + _ID
				+ " INTEGER PRIMARY KEY AUTOINCREMENT, " + LABLE + " TEXT, "
				+ SIGNATUR + " BLOB, "
				+ VORGANGS_ID + " INTIGER NOT NULL);";

		String DROP_CODE = "DROP TABLE IF EXISTS " + TABLE + ";";
	}

}
